package com.teamwork.shareplatform.mapper;

import com.teamwork.shareplatform.entity.Files;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface FilesMapper {
    @Select("SELECT * FROM files WHERE uid=#{uid}")
    List<Files> queryByUid(int uid);

   
    List<Files> queryAllFiles();
    List<Files> queryByCid(int sid);
 @Select("SELECT * FROM files")
    int deleteFiles(int id);

    @Select("SELECT path FROM files WHERE id=#{fid}")
    String queryFilePath(int fid);

 

}
